2013-04-09 - 5993.200-5994.200- Rel Notes-Freight forwarder Speed integration & FTN moving to new SFTP tradenetworks & Header Issue-Q-P #DotNetReleases2013

Release Notes

Release Notes 5993.200-5994.200- Rel Notes - DSSCO- FTN moving to new SFTP tradenetworks & Freight forwarder Speed integration & Header Issues (Q-P)

Admin Info

Purpose
 FTN moving to new SFTP tradenetworks & Freight forwarder Speed integration & Header Issues
Release No#
 001
Submitted on
 04/10/2013
Submitted by
 Sandeep J
Source/Destination Systems
 NEC QA-NED PROD
Release Sent To
 Babu Lankipalli, Baiwa Zhang
Objects Created By
 Sandeep J
Objects Tested By
 Babu Lankipalli, Sandeep J

Transport and Technical Objects

Location Objects Name
\\10.114.165.54\dev\DSSCODEV\Move to Prod\FTP
  • FTPFTN.bat
  • DSSCOPOFTPProcess
  • DSSCOPOFTPProcess.exe
  • FTPSpeed.bat
  • example.txt

\\10.114.165.54\dev\DSSCODEV\Move to Prod\FTP
  • FTP_PROD.sql

Release Notes

For Infrastructure


Please install winscp, third party tool for SFTP in PROD environment.
It can be downloaded from Web.

Please take backup of existing pages in PROD before replacing PROD page with QA Pages.

Run the below Sql Script in PROD DB: Location of script is given in Location Objects Name above:


Please create folder with Name: 'SPEED' in BACKUP and EXPORTS folders.

Test Notes


Speed:
Test Case ID
 Test Case Name
 Tested Environment
 Steps
 Expected Results
DSSCO_TC_FTP_001
 Verify a PO having Speed data in OpenPO and Openpos_prev tables .
 QA
 1.Take PO and verify the data in OPenPO and Openpos_prev tables.
 PO Number data should be preset in both OPenPO and Openpos_prev tables.
DSSCO_TC_FTP_002
 Verify exfacdate falls between current date + 30 days in OpenPOs table.
 QA
 1. Change the exfacdate in openpos table for the selected PO.
2. Run the FTP job.
 1.Exfacdate should be changed for selected PO in Openpos table.
2. PO file should be created for selected PO Number in Speed Folder.


Reference Document (Specifications or Production Support Break Fix)

2013-03-28-5993.200 -Spec-DSSCO FTP Process (FTN moving to new SFTP tradenetworks)
2013-03-28-5994.200-Spec-DSSCO FTP Process (New Carrier 'Speed' integration).
2013-04-04-5835-Break Fix-FTN PO files missing header info